MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

19 rows where Artist Alpha Sort = 3094

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Department, Object Name, Title, Artist Display Bio, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository
28109 28109 20.151.6 0 1 33284 Arms and Armor 5 Painting 69 Portrait of Walter Devereux (1539–1576), First Earl of Essex British 6         Artist 2   British Painter     British Painter 3094       dated 1572 1572 1572 Oil on wood 156 41 1/8 x 31 1/2 in. (104.5 x 80 cm) Rogers Fund, 1920                       Miscellaneous-Paintings & Portraits 163   http://www.metmuseum.org/art/collection/search/33284 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
100590 100590 95.14.18 0 1 188005 European Sculpture and Decorative Arts 3 Box, painting 7004 Box Austrian, Vienna 349         Artist 2 Miniature by unknown British Painter   , last quarter 18th century British Painter 3094 British 7     1832 1832 1832 Gold, rhinestones, enamel 20685 Box: 1 in. × 3 1/2 in. × 2 5/8 in. (2.5 × 8.9 × 6.7 cm); Miniature (sight): 2 1/16 × 1 7/16 in. (5.2 × 3.7 cm) The Moses Lazarus Collection, Gift of Josephine and Sarah Lazarus, in memory of their father, 1888-95                       Metalwork-Gold and Platinum|Paintings 334   http://www.metmuseum.org/art/collection/search/188005 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305876 305876 51.194.2 0 1 435778 European Paintings 15 Painting 69 Sir John Shurley of Isfield (1565–1632)           Artist 2   British Painter dated 1588   British Painter 3094 British 7       1588 1588 Oil on wood 156 35 3/4 x 29 3/8 in. (90.8 x 74.6 cm) Gift of Kate T. Davison, in memory of her husband, Henry Pomeroy Davison, 1951                       Paintings 11   http://www.metmuseum.org/art/collection/search/435778 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305877 305877 11.149.1 0 1 435779 European Paintings 15 Painting 69 Portrait of a Woman           Artist 2   British Painter ca. 1600   British Painter 3094 British 7     ca. 1600 1595 1605 Oil on wood 156 44 1/2 x 34 3/4 in. (113 x 88.3 cm) Gift of J. Pierpont Morgan, 1911                       Paintings 11   http://www.metmuseum.org/art/collection/search/435779 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305878 305878 17.190.2 0 0 435780 European Paintings 15 Painting 69 Mary, Queen of Scots, with Her Son, James           Artist 2 Style of 16th-century British Painter 19th century   British Painter 3094 British 7     19th century 1800 1899 Oil on slate 44502 8 7/8 x 7 3/4 in. (22.5 x 19.7 cm) Gift of J. Pierpont Morgan, 1917                       Paintings 11   http://www.metmuseum.org/art/collection/search/435780 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305879 305879 15.43.302 0 1 435781 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2   British Painter ca. 1690   British Painter 3094 British 7       1685 1695 Oil on copper 1953 Oval, 2 3/8 x 2 in. (60 x 50 mm) Bequest of Mary Anna Palmer Draper, 1914                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435781 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305880 305880 62.122.155 0 1 435782 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2   British Painter ca. 1690   British Painter 3094 British 7       1685 1695 Oil on copper 1953 Oval, 3 1/4 x 2 5/8 in. (82 x 68 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435782 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305881 305881 62.122.112 0 1 435784 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2   British Painter ca. 1740   British Painter 3094 British 7       1735 1745 Vellum laid on card 44503 Oval, 1 3/8 x 1 1/8 in. (36 x 28 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435784 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305882 305882 62.122.113 0 1 435785 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2   British Painter ca. 1750   British Painter 3094 British 7       1745 1755 Enamel 149 Oval, 1 7/8 x 1 1/2 in. (48 x 38 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435785 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305883 305883 32.75.28 0 1 435787 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2   British Painter ca. 1770   British Painter 3094 British 7       1765 1775 Ivory 148 Oval, 1 3/8 x 1 1/4 in. (36 x 30 mm) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435787 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305884 305884 95.14.96 0 1 435788 European Paintings 15 Painting, miniature 73 A Man with the Initials RH           Artist 2   British Painter ca. 1780   British Painter 3094 British 7       1775 1785 Card 44476 Oval, 2 x 1 3/8 in. (51 x 36 mm) The Moses Lazarus Collection, Gift of Josephine and Sarah Lazarus, in memory of their father, 1888–95                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435788 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305885 305885 62.122.34 0 1 435791 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2   British Painter ca. 1800   British Painter 3094 British 7       1795 1805 Ivory 148 Oval, 3 x 2 3/8 in. (77 x 60 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435791 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305886 305886 62.122.46 0 1 435792 European Paintings 15 Painting, miniature 73 Portrait of an Officer           Artist 2   British Painter ca. 1820   British Painter 3094 British 7       1815 1825 Ivory 148 Oval, 3 1/4 x 2 1/2 in. (78 x 62 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435792 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305887 305887 54.128.1 0 1 435797 European Paintings 15 Painting, miniature 73 Eye Miniature           Artist 2   British Painter early 19th century   British Painter 3094 British 7       1800 1829 Ivory 148 Irregular, 1/2 x 7/8 in. (13 x 22 mm) Gift of Mr. and Mrs. John W. Starr, 1954                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435797 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305888 305888 54.128.2 0 1 435798 European Paintings 15 Painting, miniature 73 Eye Miniature           Artist 2   British Painter early 19th century   British Painter 3094 British 7       1800 1829 Ivory 148 Oval, 1/4 x 1/2 in. (6 x 14 mm) Gift of Mr. and Mrs. John W. Starr, 1954                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435798 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305889 305889 54.128.3 0 1 435799 European Paintings 15 Painting, miniature 73 Eye Miniature           Artist 2   British Painter early 19th century   British Painter 3094 British 7       1800 1829 Ivory 148 Oval, 1/2 x 1 in. (14 x 27 mm) Gift of Mr. and Mrs. John W. Starr, 1954                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435799 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305890 305890 54.128.5 0 1 435800 European Paintings 15 Painting, miniature 73 Eye Miniature           Artist 2   British Painter early 19th century   British Painter 3094 British 7       1800 1829 Ivory 148 Diameter 1/4 in. (6 mm) Gift of Mr. and Mrs. John W. Starr, 1954                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435800 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305891 305891 54.128.7 0 1 435801 European Paintings 15 Painting, miniature 73 Eye Miniature           Artist 2   British Painter early 19th century   British Painter 3094 British 7       1800 1829 Ivory 148 Oval, 3/4 x 1/2 in. (19 x 13 mm) Gift of Mr. and Mrs. John W. Starr, 1954                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435801 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
308181 308181 2017.202.5 0 0 441355 European Paintings 15 Painting 69 Western Gentleman in Oriental Costume           Artist 2   British Painter ca. 1840–45   British Painter 3094         1840 1845 Oil on canvas 953 approx. 6 x 9 in. (15.2 x 22.9 cm) Partial and Promised Gift of Kenneth Jay Lane, 2017                       Paintings 11   http://www.metmuseum.org/art/collection/search/441355 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 200.284ms · Data license: CC0 · Data source: metmuseum/openaccess